create  external table jms_dim.dim_tab_outlets_abnormal_config_base
(
       id                           string comment '主键id',
       network_code                 string comment '网点编码',
       network_name                 string  comment '网点名称',
       effect_start_time            timestamp comment '有效开始日期',
       effect_end_time              timestamp comment '有效结束日期',
       create_by                    string  comment '创建人',
       create_time                  timestamp comment '创建时间',
       update_by                    string comment '更新人',
       update_time                  timestamp comment '更新时间',
       is_del                       string comment '是否删除'
)comment '异常报备网点配置表'
	 stored as parquet
    LOCATION
   '/dw/hive/jms_dim.db/external/dim_tab_outlets_abnormal_config_base';